Syntax error in Transaction statement. Expected TRANSACTION, WORK, or nothing. (Error 3708)

When using transactions exclusively through Microsoft« Jet (not through an object model like DAO or ADO) the following syntax must be used: BEGIN/ROLLBACK TRANSACTION, WORK or nothing. If any other characters follow BEGIN or ROLLBACK, then this error will occur.